hive外表开启Data Cache查询速度变慢

没开CACAHE的EXPLAIN: PLAN FRAGMENT 0 OUTPUT EXPRS:25: ym | 291: if | 290: order_channel_name | 295: count | 296: sum | 297: sum | 298: sum PARTITION: UNPARTITIONED

RESULT SINK

28:EXCHANGE

PLAN FRAGMENT 1 OUTPUT EXPRS: PARTITION: HASH_PARTITIONED: 25: ym, 291: if, 290: order_channel_name

STREAM DATA SINK EXCHANGE ID: 28 UNPARTITIONED

27:AGGREGATE (merge finalize) | output: count(295: count), sum(296: sum), sum(297: sum), sum(298: sum) | group by: 25: ym, 291: if, 290: order_channel_name | 26:EXCHANGE

PLAN FRAGMENT 2 OUTPUT EXPRS: PARTITION: HASH_PARTITIONED: 9: order_channel_cd

STREAM DATA SINK EXCHANGE ID: 26 HASH_PARTITIONED: 25: ym, 291: if, 290: order_channel_name

25:AGGREGATE (update serialize) | STREAMING | output: count(1), sum(292: if), sum(293: if), sum(294: if) | group by: 25: ym, 291: if, 290: order_channel_name | 24:Project | : 25: ym | : 290: order_channel_name | : if(8: sale_mode_name = ‘����’, ‘����’, ‘��ʳ’) | : if(301: expr, 1, 0) | : if((301: expr) AND (303: expr), 1, 0) | : if((((301: expr) AND (9: order_channel_cd IN (‘3rd001’, ‘3rd002’, ‘3rd003’, ‘3rd004’))) AND (303: expr)) AND (30: bill_id IS NULL), 1, 0) | common expressions: | : 22: oneid IS NOT NULL | : coalesce(11: member_id, ‘’) | : 302: coalesce != ‘’ | 23:HASH JOIN | join op: LEFT OUTER JOIN (PARTITIONED) | colocate: false, reason: | equal join conjunct: 9: order_channel_cd = 289: order_channel_cd | |----22:EXCHANGE | 20:EXCHANGE

PLAN FRAGMENT 3 OUTPUT EXPRS: PARTITION: RANDOM

STREAM DATA SINK EXCHANGE ID: 22 HASH_PARTITIONED: 289: order_channel_cd

21:HdfsScanNode TABLE: t99_order_channel_cd partitions=1/1 cardinality=1 avgRowSize=2.0 numNodes=0

PLAN FRAGMENT 4 OUTPUT EXPRS: PARTITION: HASH_PARTITIONED: 1: store_id

STREAM DATA SINK EXCHANGE ID: 20 HASH_PARTITIONED: 9: order_channel_cd

19:Project | : 8: sale_mode_name | : 9: order_channel_cd | : 11: member_id | : 22: oneid | : 25: ym | : 30: bill_id | 18:HASH JOIN | join op: LEFT OUTER JOIN (BUCKET_SHUFFLE(S)) | colocate: false, reason: | equal join conjunct: 1: store_id = 27: store_id | equal join conjunct: 26: ymd = 151: ymd | equal join conjunct: 5: bill_id = 30: bill_id | |----17:EXCHANGE | 6:Project | : 1: store_id | : 5: bill_id | : 8: sale_mode_name | : 9: order_channel_cd | : 11: member_id | : 22: oneid | : 25: ym | : 26: ymd | 5:HASH JOIN | join op: INNER JOIN (PARTITIONED) | colocate: false, reason: | equal join conjunct: 1: store_id = 183: store_id | |----4:EXCHANGE | 1:EXCHANGE

PLAN FRAGMENT 5 OUTPUT EXPRS: PARTITION: HASH_PARTITIONED: 27: store_id, 151: ymd, 30: bill_id

STREAM DATA SINK EXCHANGE ID: 17 HASH_PARTITIONED: 27: store_id

16:AGGREGATE (merge finalize) | group by: 27: store_id, 151: ymd, 30: bill_id | 15:EXCHANGE

PLAN FRAGMENT 6 OUTPUT EXPRS: PARTITION: HASH_PARTITIONED: 32: member_card_id

STREAM DATA SINK EXCHANGE ID: 15 HASH_PARTITIONED: 27: store_id, 151: ymd, 30: bill_id

14:AGGREGATE (update serialize) | STREAMING | group by: 27: store_id, 151: ymd, 30: bill_id | 13:Project | : 27: store_id | : 30: bill_id | : 151: ymd | 12:HASH JOIN | join op: INNER JOIN (PARTITIONED) | colocate: false, reason: | equal join conjunct: 32: member_card_id = 152: card_id | |----11:EXCHANGE | 9:EXCHANGE

PLAN FRAGMENT 7 OUTPUT EXPRS: PARTITION: RANDOM

STREAM DATA SINK EXCHANGE ID: 11 HASH_PARTITIONED: 152: card_id

10:HdfsScanNode TABLE: com_card_info NON-PARTITION PREDICATES: 152: card_id IS NOT NULL partitions=1/1 cardinality=1 avgRowSize=1.0 numNodes=0

PLAN FRAGMENT 8 OUTPUT EXPRS: PARTITION: RANDOM

STREAM DATA SINK EXCHANGE ID: 09 HASH_PARTITIONED: 32: member_card_id

8:Project | : 27: store_id | : 30: bill_id | : 32: member_card_id | : 151: ymd | 7:HdfsScanNode TABLE: com_pos_sale_mas PARTITION PREDICATES: 150: ym >= 202301, 150: ym = 202301, 25: ym